<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>查询通讯录信息</title>
    <style>
        h1{color: red;}
        table{ border: 4px double red; border-spacing: 0; width: 480px;}
        td, th{border-bottom: 1px dotted red; border-right: 1px dotted red; padding: 6px 10px;}
    </style>
</head>
<body>
<h1>查询通讯录信息</h1>
<?php
$db=new PDO("mysql:host=localhost; dbname=db2;", 'root', '12qwas');
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_ASSOC);
$ps=$db->query('select * from students');
echo "<table><tr><th>学号</th><th>姓名</th><th>电话</th></tr>";
foreach ($ps as $r){
    echo "<tr><td>{$r['xh']}</td><td>{$r['name']}</td><td>{$r['tel']}</td></tr>";
}
echo '</table>';
?>
</body>
</html>